Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
CustomerOrderID (FK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | CustomerOrder(DO_CTORD) |
CustomerOrderStateCode (FK) | A unique retailer assigned code denoting a potential state for a CustomerOrder. Eg: Create, DeleteItem, AddItem, ChangeItem, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete etc... | CD_STE_CTORD | Code2 | char(2) | CustomerOrderState(CO_STE_CTORD) |
CustomerOrderTypeCode (FK) | A unique retailer assigned code denoting a type of CustomerOrder Eg: Layaway, Order for Delivery, Order for Pickup, etc... | CD_TYP_CTORD | Code2 | char(2) | CustomerOrderType(CO_TYP_CTORD) |